IF/COUNTIF function help

[queens123]

Would anybody know how to go about solving this problem involving multiple variables and a countif function?

Heres my spreadsheet: -

---------A--------B---------C--------D--------E
1 ------Site -----MON -----TUE -----WED ---THU

2------ GCI -------x-------------------x

3-------TGI--------x------------------x--------x

4-------GCI------------------x-----------------x

I basically have a calendar that shows weekly bookings. Can anybody suggest a formula that I could use to count the Number of Days a week that somebody from GCI is booked?
Thanks

 

[kpark91]

=COUNTIF(B2:E4, "=x")

 

[queens123]

That would give me the total count of all the sites no (GCI and TGI)? I just want to have a count for those at GCI

 

[T. Valko]

Would anybody know how to go about solving this problem involving multiple variables and a countif function?

Heres my spreadsheet: -

---------A--------B---------C--------D--------E
1 ------Site -----MON -----TUE -----WED ---THU

2------ GCI -------x-------------------x

3-------TGI--------x------------------x--------x

4-------GCI------------------x-----------------x

I basically have a calendar that shows weekly bookings. Can anybody suggest a formula that I could use to count the Number of Days a week that somebody from GCI is booked?
Thanks

Try this...

A10 = GCI

=SUMPRODUCT((A2:A5=A10)*(B2:E5="x"))

 

[mmmarks]

try this ,
=IF(A2="GCI",COUNTIF(B2:E4,"X")," ")
<table border="0" cellpadding="0" cellspacing="0" width="64"><col width="64"><tr height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64"> </td> </tr></table><table border="0" cellpadding="0" cellspacing="0" width="64"><col width="64"><tr height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64"> </td> </tr></table>

 

[kpark91]

Try this...

A10 = GCI

=SUMPRODUCT((A2:A5=A10)*(B2:E5="x"))

Nice.

 

[queens123]

There we go, both of those work, many thanks!

 

[T. Valko]

Nice.

Thanks!

 

[T. Valko]

There we go, both of those work, many thanks!

You're welcome. Thanks for the feedback!

 

[MrVillareal]

Hi friend

Hope I can add some help

Excel Workbook
	A	B	C	D	E	F	G	H
1	Site	MON	TUE	WED	THU		Site	Count
2	GCI	x		x			GCI	4
3	TGI	x		x	x		TGI	3
4	GCI		x		x
Sheet2

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Hope your feedback